www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/fkm.cpp

    // fkm.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "fkm.h"
#include "ado.h"
#include "khfk.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// fkm dialog


fkm::fkm(CWnd* pParent /*=NULL*/)
	: CDialog(fkm::IDD, pParent)
{
	//{{AFX_DATA_INIT(fkm)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void fkm::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(fkm)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_COMBO1, m_com);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(fkm, CDialog)
	//{{AFX_MSG_MAP(fkm)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// fkm message handlers

BOOL fkm::OnInitDialog() 
{
	CDialog::OnInitDialog();
	ado rst;
	rst.Open("select * from tb_Client_khmyd",adCmdText);
	int rstnum=rst.GetRecordCount();
	int i;
	for(i=1;i<=rstnum;i++)
	{
		this->m_com.AddString(rst.GetFieldValue("khmyd_myd"));
		rst.Move(i);
	}
	rst.close();
m_list.ModifyStyle(0L,LVS_REPORT);
//	m_list.ModifyStyle(0L,LVS_SINGLESEL);
	m_list.ModifyStyle(0L,LVS_SHOWSELALWAYS);
	m_list.ModifyStyle(0L,LVS_NOSORTHEADER);
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|
		LVS_EX_FULLROWSELECT|
		LVS_EX_HEADERDRAGDROP|
		LVS_EX_ONECLICKACTIVATE);
	m_list.InsertColumn(0,"意见反馈编号");
	m_list.InsertColumn(1,"反馈标题");
	m_list.InsertColumn(2,"客户名称");
	m_list.InsertColumn(3,"反馈内容");
	m_list.InsertColumn(4,"反馈日期");
	m_list.InsertColumn(5,"受理人");
	m_list.InsertColumn(5,"客户满意度");
	m_list.InsertColumn(5,"备注信息");
	m_list.SetColumnWidth(0,100);
	m_list.SetColumnWidth(1,100);
	m_list.SetColumnWidth(2,100);
	m_list.SetColumnWidth(3,100);
	m_list.SetColumnWidth(4,100);
	m_list.SetColumnWidth(5,100);
	m_list.SetColumnWidth(6,100);
	m_list.SetColumnWidth(7,100);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void fkm::OnButton1() 
{
this->EndDialog(true);	
}
void fkm::loadlist()
{
	ado rst;
	rst.rstOpen("select * from tb_Client_khfk");
	int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("khfk_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khfk_fkbt"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khfk_khmc"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khfk_fknr"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khfk_fkrq"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khfk_fkslr"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khfk_khmyd"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khfk_bz"));
rst.Move(ii);
}
rst.close();
}

void fkm::OnButton2() 
{
	this->m_list.DeleteAllItems();
	CString com,sql;
	this->m_com.GetWindowText(com);
	if(com.IsEmpty())
	{MessageBox("请选择","提示");
	return;}
	sql.Format("select * from tb_Client_khfk where khfk_khmyd='%s'",com);
	ado rst;
	rst.Open(sql,adCmdText);
	int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("khfk_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("khfk_fkbt"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("khfk_khmc"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("khfk_fknr"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("khfk_fkrq"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("khfk_fkslr"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("khfk_khmyd"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("khfk_bz"));
rst.Move(ii);
}
	rst.close();

	
}

void fkm::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int i=m_list.GetHotItem();
	if(i<0)
	{return;}
	KHFK fk;
	
	fk.edit1=this->m_list.GetItemText(i,0);
	fk.edit2=this->m_list.GetItemText(i,1);
	fk.edit5=this->m_list.GetItemText(i,2);
	fk.edit6=this->m_list.GetItemText(i,3);
	fk.edit7=this->m_list.GetItemText(i,4);
	fk.DoModal();
	*pResult = 0;
}